Excel 2021: A Step-by-Step Guide to Learn the Basics of Excel Software Through a Smart Approach by Blake Albert

Author:Blake, Albert [Blake, Albert]
Language: eng
Format: epub, mobi
Published: 2021-07-19T00:00:00+00:00

Example:

In an employee timesheet, the user should only enter dates that fall during the existing or designated week (September 2–8, 2019).

How to Create Text Length-Based Rule

You can also make a rule that the cell can only allow texts that are less than a certain number of characters long.

Follow these steps:

• Choose the cell(s) on which the rule would be applied.

• Choose “Text length” under “Allow” in the data validation dialogue box.

• Choose the correct parameters from the “Data” menu.

• Fill in the blanks with the necessary information.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.